61. Account Aged Analysis - Database Profiles Datafile Software Account Aged Analysis - Database Profiles Data Item Type Alternative Notes Forward K L Holds the aged values on this account as generated by the Save Aged Analysis option. This FORWARD value is only updated/required if ageing o... Read More
62. Account Statements (Sales Ledger) - Database Profiles Datafile Software Account Statements (Sales Ledger) - Database Profiles Data Item Type Alternative Notes Last Statement date D E Date when a statement was last printed for this account, only applicable if statement set to update the date. State... Read More
63. Account Invoicing (Sales Ledger) - Database Profiles Datafile Software Account Invoicing (Sales Ledger) - Database Profiles Data Item Type Alternative Notes Inv Cost: First Y(6) N, Y(5–8) First record number of an invoice costing record for this account. Inv Cost: Last Y(6) N, Y(5–8) Last reco... Read More
64. Account Currency - Database Profiles Datafile Software Account Currency - Database Profiles Data Item Type Alternative Notes Currency Code X(3) The three-character currency code Curr Bal-bf L K This, and the following, values mirror in the foreign currency the base currency values ... Read More
65. Account Currency Turnover - Database Profiles Datafile Software Account Currency Turnover - Database Profiles Data Item Type Alternative Notes Curr T/O for year L K These values mirror in the foreign currency the base currency values Curr T/O for period L K Curr T/O per 1–13 L K Curr T/O... Read More
66. Trans Mandatory - Database Profiles Datafile Software Trans Mandatory - Database Profiles Data Item Type Alternative Notes Transaction type Y(1) X(1) Holds the type of the transaction record.: 1 Invoice transaction 2 Payment transaction 3 Credit note transaction 4 Invoice ad... Read More
67. Trans Optional 1 - Database Profiles Datafile Software Trans Optional 1 - Database Profiles Data Item Type Alternative Notes Nominal code X (10) Y Only used in type 6–9 analysis records, plus types2 and 5 payments Nominal updated ?-type Nominal ledger changes this to Y as it post... Read More
68. Trans Optional 2 - Database Profiles Datafile Software Trans Optional 2 - Database Profiles Data Item Type Alternative Notes Job Reference X (10) Y Purchase Ledger Only. This item used to hold the job code if ledger linked to job costing. Job Code Analysis X (10) Y Purchase Ledger ... Read More
69. Trans Optional 3 - Database Profiles Datafile Software Trans Optional 3 - Database Profiles Data Item Type Alternative Notes EC Country X (3) Copied from accounts file; needed for EC reports EC Tax Reg X (15) Copied from accounts file; needed for EC reports EC Acquis Tax L K Purch... Read More
70. Trans Cash Tax - Database Profiles Datafile Software Trans Cash Tax - Database Profiles Used for cash accounting purposes, where tax is payable only when invoices are paid. All three must be present in your files for this feature to function. Data Item Type Alternative Notes Tax ... Read More